﻿CREATE PROCEDURE [dbo].[usp_UserApplication_Sel]
@ID INT
AS
BEGIN

DECLARE @ErrorCode AS INT
DECLARE @RowsAffected AS INT

SELECT [ID], [NTUserName], [ApplicationName], [TimeStmp], [CreateDt], [CreateUid], [RevMdlName], [RevDt], [RevUid] FROM [UserApplication]
    WHERE ([ID] = @ID)
    OPTION (FAST 1)

SELECT @ErrorCode = @@ERROR, @RowsAffected = @@ROWCOUNT

RETURN @ErrorCode

END

